Mega Code Archive
Data Type
1) A table definition that uses the DECIMAL and FLOAT data types
2) Add to mytbl an ENUM column e that has several members
3) Add zero to the values to force a string-to-number conversion
4) An AUTO_INCREMENT column
5) An ENUM column definition may list up to 65,535 members
6) An important one to note; the result is not 0 (false), its NULL
7) Assuming that NULL values sort ahead of all non-NULL values
8) AUTO_INCREMENT column
9) AUTO_INCREMENT Integers
10) AUTO_INCREMENT sequences start at one
11) BIGINT(m)
12) BIT(n)
13) Binary data types support the storage of large amounts of data, such as image and sound files
14) BLOB Binary data with variable length, maximum 2^16-1 bytes
15) CHAR and VARCHAR types are searched case insensitively, unless you use the BINARY keyword
16) CHAR(n)
17) Compare char type value
18) Compare smallint value
19) Compare varchar value
20) Compare with Date value
21) Compare with integer literal
22) Compare with integers
23) Concatenate string with NULL value
24) Configure an ENUM column and a SET column
25) Consider changing the column type to ENUM, if you always sort a non-enumeration column in a specific non-lexic
26) Converting Data to Different Types
27) Create a similar table, preserve the auto-incrementing key
28) Create a table in which timestamps can be stored
29) Create a table with TEXT type column
30) Create table
31) CREATE TABLE statement including two column definitions, SMALLINT data type and INT data type
32) Data Types in MySQL
33) Date calculation with variable
34) Date default value
35) Date literal in where clause
36) Date type value in the form 2003-12-31, range 1000-01-01 to 9999-12-31 (3 bytes)
37) Date type value inside in operator and subquery
38) Date value literal
39) Dates and times in SQL commands must be given as character strings
40) DATETIME
41) Datetime as column type
42) Dealing With NULL Data
43) DECIMAL(4,2) for price
44) DECIMAL(7,2)
45) DECIMAL(7,2) ZEROFILL NOT NULL
46) DECIMAL(p, s) Fixed-point number, saved as a character string
47) Decimal and Numeric Data Field Syntax When 123 4567 Is Inserted
48) Decimal default value
49) Default null value for Int type column
50) Define and use ENUM data type
51) Define and use small int
52) Define and use tiny int
53) Define and use varchar
54) Define Male and Female as Enum
55) Defining Auto-Increment Columns
56) Delete and reinsert value to AUTO_INCREMENT column
57) Disallowing NULLs
58) DOUBLE(m, d)
59) ENUM
60) Enum for month names
61) Enum type column
62) Enum value index
63) Enumerating a Many-to-Many Relationship
64) Enumeration values arent limited to being single letters or uppercase
65) Float type column type
66) FLOAT(10,3)
67) FLOAT(19,3) ZEROFILL
68) FLOAT(m, d)
69) For MyISAM tables, you can begin the sequence at a specific initial value n by including an AUTO_INCREMENT = n
70) Get the values of the literals TRUE and FALSE
71) How MySQL deals with incorrect date value
72) How MySQL deals with non-exist number
73) How MySQL store true and false
74) use enum
75) If the value of an expression cannot be determined, the result is NULL
76) If this value is larger than the current sequence counter, subsequent automatically generated values begin with the value plus o
77) If you add an invalid value to ENUM columns, an empty string () is inserted instead
78) If you are comparing strings and numerics, or floating-point numbers and integers, MySQL will compare them as
79) Insert String value as ENUM
80) Insert value to a decimal value column
81) Insert value to AUTO_INCREMENT column
82) Insert value to enum type column
83) INT UNSIGNED
84) Int value
85) Int(11) not null
86) INT(m), INTEGER(m)
87) Integer Types in MySQL with Sizes and Ranges
88) INTEGER UNSIGNED AUTO_INCREMENT
89) INTEGER(4) ZEROFILL
90) IS NOT NULL in where clause
91) Issuing an UPDATE statement that doesnt actually change the values in the val column doesnt update the TIMES
92) List NOT NULL value and order it
93) LONGBLOB Binary data with variable length, maximum 2^32-1 bytes
94) LONGTEXT character string with variable length, maximum 2^32-1 characters
95) Max with char type values
96) MEDIUMBLOB Binary data with variable length, maximum 2^24-1 bytes
97) MEDIUMINT NOT NULL AUTO_INCREMENT
98) MEDIUMINT(m)
99) MEDIUMTEXT character string with variable length, maximum 2^24-1 characters
100) Microseconds component is removed
101) Minus a constant value
102) MySQL evaluates a true expression to 1 and a false expression to 0
103) MySQL uses the internal numeric values for sorting for enum value
104) Not equal char type value
105) Not null char type column
106) Not null tinyint and AUTO_INCREMENT
107) Not null varchar column
108) NULL is basically a third possible result of an evaluation
109) NULL means not having a value
110) NULL value in where clause
111) Nullable varchar column
112) Number Data types in MySQL
113) NUMERIC, DEC Synonym for DECIMAL
114) Numeric Column Types
115) Order by DATETIME
116) Order by enum value
117) Order by time value
118) Order by timestamp value
119) Parameter
120) Passing a NULL value to a function results in a NULL return value
121) Perform queries on enumerated fields based on their indexes
122) Performing Calculations with TIMESTAMP Values
123) Preserve column attributes such as AUTO_INCREMENT and columns default value during table copying
124) Produce a time-of-day summary for records
125) Quoting a string value
126) Read NULL value
127) REAL(m, d)
128) Recording a Rows Creation Time
129) Recording a Rows Last Modification Time
130) Retrieve NOT NULL value
131) Retrieve NULL value
132) Select NOT NULL value
133) Select only one value among the set
134) SERIAL
135) SET
136) SET @@AUTO_INCREMENT_OFFSET = 10,@@AUTO_INCREMENT_INCREMENT = 10
137) Set AUTO_INCREMENT value
138) Set multiple values
139) Set value to null
140) Sets work in a similar way to enumerated fields
141) Setting M to a higher value than the type allows will not allow you to extend its limit
142) SmallInt calculation
143) SMALLINT data type and a default value of 1
144) SMALLINT(m)
145) Sort ENUM values in lexical order
146) Sorting by Calendar Day
147) Sorting by Time of Day
148) Sorting ENUM Values
149) Storage Comparisons of ENUM and SET
150) Table definition includes a BLOB column named Photo
151) Table definition includes a YEAR column and a TIMESTAMP
152) Testing String Equality or Relative Ordering
153) TEXT and BLOB Data Type Sizes and Upper Limits (in Bytes)
154) TEXT character string with variable length, maximum 2^16-1 characters
155) The CHAR data type is a fixed-length character data type that can store up to 255 characters
156) The difference between the creation and modification times
157) The ENUM and SET Column Types
158) The fractional data types
159) The SET datatype, like ENUM, is declared using a comma-separated list of quoted strings that define its valid
160) The width specification is most often used with zerofill
161) TIME
162) TIMESTAMP as column type
163) TINYBLOB
164) TINYINT(m) 8-bit integer (1 byte, -128 to +127)
165) TINYTEXT character string with variable length
166) Timestamp type column default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
167) Tinyint as column type
168) To break down a set of observations and show each count as a percentage of the total
169) To evaluate NULL rows
170) To find out whether a string lies within a given range of values (inclusive)
171) To find the row with the most recent birth date, the query is similar, except that you sort in descending orde
172) To identify SET values that share common elements
173) To include a quote character within a string that is quoted by the same kind of quote
174) Update decimal value
175) Updates to tsdemo2 records that dont actually modify a column cause no change to TIMESTAMP values
176) Use ALTER TABLE to convert the name column to an ENUM that lists the colors in the desired sort order
177) Use operators to specify a range of values
178) Use SET to have arbitrary combinations
179) Use smallint to store year
180) Use the IS NULL (or IS NOT NULL) comparison instead
181) Use the IS NULL and IS NOT NULL operators
182) Use two ENUM data type in a table
183) Using an AUTO_INCREMENT Column to Create Multiple Sequences
184) Using AUTO_INCREMENT
185) Using foreign key as an enum type
186) Varchar type column with collate latin1_german1_ci
187) VARCHAR(n) character string with variable length, maximum 65,535 characters
188) What is the result of the calculation 10 divided by 0
189) With ENUM you can manage a list of up to 65,535 character strings
190) Working with NULL Values
191) Writing Strings That Include Quotes or Special Characters
192) YEAR
193) You can replace the hyphen (-) and colon (